package com.zheng.business.dao.model;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BusinessOrderUmbrellaTimecardExample implements Serializable {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private static final long serialVersionUID = 1L;

    public BusinessOrderUmbrellaTimecardExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria implements Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNull() {
            addCriterion("OrderNo is null");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNotNull() {
            addCriterion("OrderNo is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernoEqualTo(String value) {
            addCriterion("OrderNo =", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotEqualTo(String value) {
            addCriterion("OrderNo <>", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThan(String value) {
            addCriterion("OrderNo >", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThanOrEqualTo(String value) {
            addCriterion("OrderNo >=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThan(String value) {
            addCriterion("OrderNo <", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThanOrEqualTo(String value) {
            addCriterion("OrderNo <=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLike(String value) {
            addCriterion("OrderNo like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotLike(String value) {
            addCriterion("OrderNo not like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoIn(List<String> values) {
            addCriterion("OrderNo in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotIn(List<String> values) {
            addCriterion("OrderNo not in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoBetween(String value1, String value2) {
            addCriterion("OrderNo between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotBetween(String value1, String value2) {
            addCriterion("OrderNo not between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andPayorderidIsNull() {
            addCriterion("PayOrderId is null");
            return (Criteria) this;
        }

        public Criteria andPayorderidIsNotNull() {
            addCriterion("PayOrderId is not null");
            return (Criteria) this;
        }

        public Criteria andPayorderidEqualTo(String value) {
            addCriterion("PayOrderId =", value, "payorderid");
            return (Criteria) this;
        }

        public Criteria andPayorderidNotEqualTo(String value) {
            addCriterion("PayOrderId <>", value, "payorderid");
            return (Criteria) this;
        }

        public Criteria andPayorderidGreaterThan(String value) {
            addCriterion("PayOrderId >", value, "payorderid");
            return (Criteria) this;
        }

        public Criteria andPayorderidGreaterThanOrEqualTo(String value) {
            addCriterion("PayOrderId >=", value, "payorderid");
            return (Criteria) this;
        }

        public Criteria andPayorderidLessThan(String value) {
            addCriterion("PayOrderId <", value, "payorderid");
            return (Criteria) this;
        }

        public Criteria andPayorderidLessThanOrEqualTo(String value) {
            addCriterion("PayOrderId <=", value, "payorderid");
            return (Criteria) this;
        }

        public Criteria andPayorderidLike(String value) {
            addCriterion("PayOrderId like", value, "payorderid");
            return (Criteria) this;
        }

        public Criteria andPayorderidNotLike(String value) {
            addCriterion("PayOrderId not like", value, "payorderid");
            return (Criteria) this;
        }

        public Criteria andPayorderidIn(List<String> values) {
            addCriterion("PayOrderId in", values, "payorderid");
            return (Criteria) this;
        }

        public Criteria andPayorderidNotIn(List<String> values) {
            addCriterion("PayOrderId not in", values, "payorderid");
            return (Criteria) this;
        }

        public Criteria andPayorderidBetween(String value1, String value2) {
            addCriterion("PayOrderId between", value1, value2, "payorderid");
            return (Criteria) this;
        }

        public Criteria andPayorderidNotBetween(String value1, String value2) {
            addCriterion("PayOrderId not between", value1, value2, "payorderid");
            return (Criteria) this;
        }

        public Criteria andChannelordernoIsNull() {
            addCriterion("ChannelOrderNo is null");
            return (Criteria) this;
        }

        public Criteria andChannelordernoIsNotNull() {
            addCriterion("ChannelOrderNo is not null");
            return (Criteria) this;
        }

        public Criteria andChannelordernoEqualTo(String value) {
            addCriterion("ChannelOrderNo =", value, "channelorderno");
            return (Criteria) this;
        }

        public Criteria andChannelordernoNotEqualTo(String value) {
            addCriterion("ChannelOrderNo <>", value, "channelorderno");
            return (Criteria) this;
        }

        public Criteria andChannelordernoGreaterThan(String value) {
            addCriterion("ChannelOrderNo >", value, "channelorderno");
            return (Criteria) this;
        }

        public Criteria andChannelordernoGreaterThanOrEqualTo(String value) {
            addCriterion("ChannelOrderNo >=", value, "channelorderno");
            return (Criteria) this;
        }

        public Criteria andChannelordernoLessThan(String value) {
            addCriterion("ChannelOrderNo <", value, "channelorderno");
            return (Criteria) this;
        }

        public Criteria andChannelordernoLessThanOrEqualTo(String value) {
            addCriterion("ChannelOrderNo <=", value, "channelorderno");
            return (Criteria) this;
        }

        public Criteria andChannelordernoLike(String value) {
            addCriterion("ChannelOrderNo like", value, "channelorderno");
            return (Criteria) this;
        }

        public Criteria andChannelordernoNotLike(String value) {
            addCriterion("ChannelOrderNo not like", value, "channelorderno");
            return (Criteria) this;
        }

        public Criteria andChannelordernoIn(List<String> values) {
            addCriterion("ChannelOrderNo in", values, "channelorderno");
            return (Criteria) this;
        }

        public Criteria andChannelordernoNotIn(List<String> values) {
            addCriterion("ChannelOrderNo not in", values, "channelorderno");
            return (Criteria) this;
        }

        public Criteria andChannelordernoBetween(String value1, String value2) {
            addCriterion("ChannelOrderNo between", value1, value2, "channelorderno");
            return (Criteria) this;
        }

        public Criteria andChannelordernoNotBetween(String value1, String value2) {
            addCriterion("ChannelOrderNo not between", value1, value2, "channelorderno");
            return (Criteria) this;
        }

        public Criteria andChannelmchidIsNull() {
            addCriterion("ChannelMchId is null");
            return (Criteria) this;
        }

        public Criteria andChannelmchidIsNotNull() {
            addCriterion("ChannelMchId is not null");
            return (Criteria) this;
        }

        public Criteria andChannelmchidEqualTo(String value) {
            addCriterion("ChannelMchId =", value, "channelmchid");
            return (Criteria) this;
        }

        public Criteria andChannelmchidNotEqualTo(String value) {
            addCriterion("ChannelMchId <>", value, "channelmchid");
            return (Criteria) this;
        }

        public Criteria andChannelmchidGreaterThan(String value) {
            addCriterion("ChannelMchId >", value, "channelmchid");
            return (Criteria) this;
        }

        public Criteria andChannelmchidGreaterThanOrEqualTo(String value) {
            addCriterion("ChannelMchId >=", value, "channelmchid");
            return (Criteria) this;
        }

        public Criteria andChannelmchidLessThan(String value) {
            addCriterion("ChannelMchId <", value, "channelmchid");
            return (Criteria) this;
        }

        public Criteria andChannelmchidLessThanOrEqualTo(String value) {
            addCriterion("ChannelMchId <=", value, "channelmchid");
            return (Criteria) this;
        }

        public Criteria andChannelmchidLike(String value) {
            addCriterion("ChannelMchId like", value, "channelmchid");
            return (Criteria) this;
        }

        public Criteria andChannelmchidNotLike(String value) {
            addCriterion("ChannelMchId not like", value, "channelmchid");
            return (Criteria) this;
        }

        public Criteria andChannelmchidIn(List<String> values) {
            addCriterion("ChannelMchId in", values, "channelmchid");
            return (Criteria) this;
        }

        public Criteria andChannelmchidNotIn(List<String> values) {
            addCriterion("ChannelMchId not in", values, "channelmchid");
            return (Criteria) this;
        }

        public Criteria andChannelmchidBetween(String value1, String value2) {
            addCriterion("ChannelMchId between", value1, value2, "channelmchid");
            return (Criteria) this;
        }

        public Criteria andChannelmchidNotBetween(String value1, String value2) {
            addCriterion("ChannelMchId not between", value1, value2, "channelmchid");
            return (Criteria) this;
        }

        public Criteria andMchidIsNull() {
            addCriterion("MchId is null");
            return (Criteria) this;
        }

        public Criteria andMchidIsNotNull() {
            addCriterion("MchId is not null");
            return (Criteria) this;
        }

        public Criteria andMchidEqualTo(String value) {
            addCriterion("MchId =", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidNotEqualTo(String value) {
            addCriterion("MchId <>", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidGreaterThan(String value) {
            addCriterion("MchId >", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidGreaterThanOrEqualTo(String value) {
            addCriterion("MchId >=", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidLessThan(String value) {
            addCriterion("MchId <", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidLessThanOrEqualTo(String value) {
            addCriterion("MchId <=", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidLike(String value) {
            addCriterion("MchId like", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidNotLike(String value) {
            addCriterion("MchId not like", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidIn(List<String> values) {
            addCriterion("MchId in", values, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidNotIn(List<String> values) {
            addCriterion("MchId not in", values, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidBetween(String value1, String value2) {
            addCriterion("MchId between", value1, value2, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidNotBetween(String value1, String value2) {
            addCriterion("MchId not between", value1, value2, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchordernoIsNull() {
            addCriterion("MchOrderNo is null");
            return (Criteria) this;
        }

        public Criteria andMchordernoIsNotNull() {
            addCriterion("MchOrderNo is not null");
            return (Criteria) this;
        }

        public Criteria andMchordernoEqualTo(String value) {
            addCriterion("MchOrderNo =", value, "mchorderno");
            return (Criteria) this;
        }

        public Criteria andMchordernoNotEqualTo(String value) {
            addCriterion("MchOrderNo <>", value, "mchorderno");
            return (Criteria) this;
        }

        public Criteria andMchordernoGreaterThan(String value) {
            addCriterion("MchOrderNo >", value, "mchorderno");
            return (Criteria) this;
        }

        public Criteria andMchordernoGreaterThanOrEqualTo(String value) {
            addCriterion("MchOrderNo >=", value, "mchorderno");
            return (Criteria) this;
        }

        public Criteria andMchordernoLessThan(String value) {
            addCriterion("MchOrderNo <", value, "mchorderno");
            return (Criteria) this;
        }

        public Criteria andMchordernoLessThanOrEqualTo(String value) {
            addCriterion("MchOrderNo <=", value, "mchorderno");
            return (Criteria) this;
        }

        public Criteria andMchordernoLike(String value) {
            addCriterion("MchOrderNo like", value, "mchorderno");
            return (Criteria) this;
        }

        public Criteria andMchordernoNotLike(String value) {
            addCriterion("MchOrderNo not like", value, "mchorderno");
            return (Criteria) this;
        }

        public Criteria andMchordernoIn(List<String> values) {
            addCriterion("MchOrderNo in", values, "mchorderno");
            return (Criteria) this;
        }

        public Criteria andMchordernoNotIn(List<String> values) {
            addCriterion("MchOrderNo not in", values, "mchorderno");
            return (Criteria) this;
        }

        public Criteria andMchordernoBetween(String value1, String value2) {
            addCriterion("MchOrderNo between", value1, value2, "mchorderno");
            return (Criteria) this;
        }

        public Criteria andMchordernoNotBetween(String value1, String value2) {
            addCriterion("MchOrderNo not between", value1, value2, "mchorderno");
            return (Criteria) this;
        }

        public Criteria andChannelidIsNull() {
            addCriterion("ChannelId is null");
            return (Criteria) this;
        }

        public Criteria andChannelidIsNotNull() {
            addCriterion("ChannelId is not null");
            return (Criteria) this;
        }

        public Criteria andChannelidEqualTo(String value) {
            addCriterion("ChannelId =", value, "channelid");
            return (Criteria) this;
        }

        public Criteria andChannelidNotEqualTo(String value) {
            addCriterion("ChannelId <>", value, "channelid");
            return (Criteria) this;
        }

        public Criteria andChannelidGreaterThan(String value) {
            addCriterion("ChannelId >", value, "channelid");
            return (Criteria) this;
        }

        public Criteria andChannelidGreaterThanOrEqualTo(String value) {
            addCriterion("ChannelId >=", value, "channelid");
            return (Criteria) this;
        }

        public Criteria andChannelidLessThan(String value) {
            addCriterion("ChannelId <", value, "channelid");
            return (Criteria) this;
        }

        public Criteria andChannelidLessThanOrEqualTo(String value) {
            addCriterion("ChannelId <=", value, "channelid");
            return (Criteria) this;
        }

        public Criteria andChannelidLike(String value) {
            addCriterion("ChannelId like", value, "channelid");
            return (Criteria) this;
        }

        public Criteria andChannelidNotLike(String value) {
            addCriterion("ChannelId not like", value, "channelid");
            return (Criteria) this;
        }

        public Criteria andChannelidIn(List<String> values) {
            addCriterion("ChannelId in", values, "channelid");
            return (Criteria) this;
        }

        public Criteria andChannelidNotIn(List<String> values) {
            addCriterion("ChannelId not in", values, "channelid");
            return (Criteria) this;
        }

        public Criteria andChannelidBetween(String value1, String value2) {
            addCriterion("ChannelId between", value1, value2, "channelid");
            return (Criteria) this;
        }

        public Criteria andChannelidNotBetween(String value1, String value2) {
            addCriterion("ChannelId not between", value1, value2, "channelid");
            return (Criteria) this;
        }

        public Criteria andRuleidIsNull() {
            addCriterion("ruleId is null");
            return (Criteria) this;
        }

        public Criteria andRuleidIsNotNull() {
            addCriterion("ruleId is not null");
            return (Criteria) this;
        }

        public Criteria andRuleidEqualTo(Integer value) {
            addCriterion("ruleId =", value, "ruleid");
            return (Criteria) this;
        }

        public Criteria andRuleidNotEqualTo(Integer value) {
            addCriterion("ruleId <>", value, "ruleid");
            return (Criteria) this;
        }

        public Criteria andRuleidGreaterThan(Integer value) {
            addCriterion("ruleId >", value, "ruleid");
            return (Criteria) this;
        }

        public Criteria andRuleidGreaterThanOrEqualTo(Integer value) {
            addCriterion("ruleId >=", value, "ruleid");
            return (Criteria) this;
        }

        public Criteria andRuleidLessThan(Integer value) {
            addCriterion("ruleId <", value, "ruleid");
            return (Criteria) this;
        }

        public Criteria andRuleidLessThanOrEqualTo(Integer value) {
            addCriterion("ruleId <=", value, "ruleid");
            return (Criteria) this;
        }

        public Criteria andRuleidIn(List<Integer> values) {
            addCriterion("ruleId in", values, "ruleid");
            return (Criteria) this;
        }

        public Criteria andRuleidNotIn(List<Integer> values) {
            addCriterion("ruleId not in", values, "ruleid");
            return (Criteria) this;
        }

        public Criteria andRuleidBetween(Integer value1, Integer value2) {
            addCriterion("ruleId between", value1, value2, "ruleid");
            return (Criteria) this;
        }

        public Criteria andRuleidNotBetween(Integer value1, Integer value2) {
            addCriterion("ruleId not between", value1, value2, "ruleid");
            return (Criteria) this;
        }

        public Criteria andAgentidIsNull() {
            addCriterion("AgentId is null");
            return (Criteria) this;
        }

        public Criteria andAgentidIsNotNull() {
            addCriterion("AgentId is not null");
            return (Criteria) this;
        }

        public Criteria andAgentidEqualTo(Integer value) {
            addCriterion("AgentId =", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotEqualTo(Integer value) {
            addCriterion("AgentId <>", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidGreaterThan(Integer value) {
            addCriterion("AgentId >", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidGreaterThanOrEqualTo(Integer value) {
            addCriterion("AgentId >=", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidLessThan(Integer value) {
            addCriterion("AgentId <", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidLessThanOrEqualTo(Integer value) {
            addCriterion("AgentId <=", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidIn(List<Integer> values) {
            addCriterion("AgentId in", values, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotIn(List<Integer> values) {
            addCriterion("AgentId not in", values, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidBetween(Integer value1, Integer value2) {
            addCriterion("AgentId between", value1, value2, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotBetween(Integer value1, Integer value2) {
            addCriterion("AgentId not between", value1, value2, "agentid");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNull() {
            addCriterion("NickName is null");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNotNull() {
            addCriterion("NickName is not null");
            return (Criteria) this;
        }

        public Criteria andNicknameEqualTo(String value) {
            addCriterion("NickName =", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotEqualTo(String value) {
            addCriterion("NickName <>", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThan(String value) {
            addCriterion("NickName >", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThanOrEqualTo(String value) {
            addCriterion("NickName >=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThan(String value) {
            addCriterion("NickName <", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThanOrEqualTo(String value) {
            addCriterion("NickName <=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLike(String value) {
            addCriterion("NickName like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotLike(String value) {
            addCriterion("NickName not like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameIn(List<String> values) {
            addCriterion("NickName in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotIn(List<String> values) {
            addCriterion("NickName not in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameBetween(String value1, String value2) {
            addCriterion("NickName between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotBetween(String value1, String value2) {
            addCriterion("NickName not between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("userId is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("userId is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(Integer value) {
            addCriterion("userId =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(Integer value) {
            addCriterion("userId <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(Integer value) {
            addCriterion("userId >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(Integer value) {
            addCriterion("userId >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(Integer value) {
            addCriterion("userId <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(Integer value) {
            addCriterion("userId <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<Integer> values) {
            addCriterion("userId in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<Integer> values) {
            addCriterion("userId not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(Integer value1, Integer value2) {
            addCriterion("userId between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(Integer value1, Integer value2) {
            addCriterion("userId not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andPaytypeIsNull() {
            addCriterion("paytype is null");
            return (Criteria) this;
        }

        public Criteria andPaytypeIsNotNull() {
            addCriterion("paytype is not null");
            return (Criteria) this;
        }

        public Criteria andPaytypeEqualTo(Integer value) {
            addCriterion("paytype =", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotEqualTo(Integer value) {
            addCriterion("paytype <>", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeGreaterThan(Integer value) {
            addCriterion("paytype >", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("paytype >=", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLessThan(Integer value) {
            addCriterion("paytype <", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLessThanOrEqualTo(Integer value) {
            addCriterion("paytype <=", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeIn(List<Integer> values) {
            addCriterion("paytype in", values, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotIn(List<Integer> values) {
            addCriterion("paytype not in", values, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeBetween(Integer value1, Integer value2) {
            addCriterion("paytype between", value1, value2, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotBetween(Integer value1, Integer value2) {
            addCriterion("paytype not between", value1, value2, "paytype");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("CreateTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("CreateTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("CreateTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CreateTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("CreateTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("CreateTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("CreateTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("CreateTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("CreateTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("CreateTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeIsNull() {
            addCriterion("ExpireTime is null");
            return (Criteria) this;
        }

        public Criteria andExpiretimeIsNotNull() {
            addCriterion("ExpireTime is not null");
            return (Criteria) this;
        }

        public Criteria andExpiretimeEqualTo(Date value) {
            addCriterion("ExpireTime =", value, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeNotEqualTo(Date value) {
            addCriterion("ExpireTime <>", value, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeGreaterThan(Date value) {
            addCriterion("ExpireTime >", value, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ExpireTime >=", value, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeLessThan(Date value) {
            addCriterion("ExpireTime <", value, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeLessThanOrEqualTo(Date value) {
            addCriterion("ExpireTime <=", value, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeIn(List<Date> values) {
            addCriterion("ExpireTime in", values, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeNotIn(List<Date> values) {
            addCriterion("ExpireTime not in", values, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeBetween(Date value1, Date value2) {
            addCriterion("ExpireTime between", value1, value2, "expiretime");
            return (Criteria) this;
        }

        public Criteria andExpiretimeNotBetween(Date value1, Date value2) {
            addCriterion("ExpireTime not between", value1, value2, "expiretime");
            return (Criteria) this;
        }

        public Criteria andPaysucctimeIsNull() {
            addCriterion("PaySuccTime is null");
            return (Criteria) this;
        }

        public Criteria andPaysucctimeIsNotNull() {
            addCriterion("PaySuccTime is not null");
            return (Criteria) this;
        }

        public Criteria andPaysucctimeEqualTo(Date value) {
            addCriterion("PaySuccTime =", value, "paysucctime");
            return (Criteria) this;
        }

        public Criteria andPaysucctimeNotEqualTo(Date value) {
            addCriterion("PaySuccTime <>", value, "paysucctime");
            return (Criteria) this;
        }

        public Criteria andPaysucctimeGreaterThan(Date value) {
            addCriterion("PaySuccTime >", value, "paysucctime");
            return (Criteria) this;
        }

        public Criteria andPaysucctimeGreaterThanOrEqualTo(Date value) {
            addCriterion("PaySuccTime >=", value, "paysucctime");
            return (Criteria) this;
        }

        public Criteria andPaysucctimeLessThan(Date value) {
            addCriterion("PaySuccTime <", value, "paysucctime");
            return (Criteria) this;
        }

        public Criteria andPaysucctimeLessThanOrEqualTo(Date value) {
            addCriterion("PaySuccTime <=", value, "paysucctime");
            return (Criteria) this;
        }

        public Criteria andPaysucctimeIn(List<Date> values) {
            addCriterion("PaySuccTime in", values, "paysucctime");
            return (Criteria) this;
        }

        public Criteria andPaysucctimeNotIn(List<Date> values) {
            addCriterion("PaySuccTime not in", values, "paysucctime");
            return (Criteria) this;
        }

        public Criteria andPaysucctimeBetween(Date value1, Date value2) {
            addCriterion("PaySuccTime between", value1, value2, "paysucctime");
            return (Criteria) this;
        }

        public Criteria andPaysucctimeNotBetween(Date value1, Date value2) {
            addCriterion("PaySuccTime not between", value1, value2, "paysucctime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterion("UpdateTime =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterion("UpdateTime <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterion("UpdateTime >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UpdateTime >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterion("UpdateTime <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterion("UpdateTime <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterion("UpdateTime in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterion("UpdateTime not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterion("UpdateTime between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterion("UpdateTime not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andAmountIsNull() {
            addCriterion("Amount is null");
            return (Criteria) this;
        }

        public Criteria andAmountIsNotNull() {
            addCriterion("Amount is not null");
            return (Criteria) this;
        }

        public Criteria andAmountEqualTo(BigDecimal value) {
            addCriterion("Amount =", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotEqualTo(BigDecimal value) {
            addCriterion("Amount <>", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThan(BigDecimal value) {
            addCriterion("Amount >", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Amount >=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThan(BigDecimal value) {
            addCriterion("Amount <", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Amount <=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountIn(List<BigDecimal> values) {
            addCriterion("Amount in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotIn(List<BigDecimal> values) {
            addCriterion("Amount not in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Amount between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Amount not between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andPayamountIsNull() {
            addCriterion("PayAmount is null");
            return (Criteria) this;
        }

        public Criteria andPayamountIsNotNull() {
            addCriterion("PayAmount is not null");
            return (Criteria) this;
        }

        public Criteria andPayamountEqualTo(BigDecimal value) {
            addCriterion("PayAmount =", value, "payamount");
            return (Criteria) this;
        }

        public Criteria andPayamountNotEqualTo(BigDecimal value) {
            addCriterion("PayAmount <>", value, "payamount");
            return (Criteria) this;
        }

        public Criteria andPayamountGreaterThan(BigDecimal value) {
            addCriterion("PayAmount >", value, "payamount");
            return (Criteria) this;
        }

        public Criteria andPayamountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PayAmount >=", value, "payamount");
            return (Criteria) this;
        }

        public Criteria andPayamountLessThan(BigDecimal value) {
            addCriterion("PayAmount <", value, "payamount");
            return (Criteria) this;
        }

        public Criteria andPayamountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PayAmount <=", value, "payamount");
            return (Criteria) this;
        }

        public Criteria andPayamountIn(List<BigDecimal> values) {
            addCriterion("PayAmount in", values, "payamount");
            return (Criteria) this;
        }

        public Criteria andPayamountNotIn(List<BigDecimal> values) {
            addCriterion("PayAmount not in", values, "payamount");
            return (Criteria) this;
        }

        public Criteria andPayamountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PayAmount between", value1, value2, "payamount");
            return (Criteria) this;
        }

        public Criteria andPayamountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PayAmount not between", value1, value2, "payamount");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("Status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("Status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("Status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("Status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("Status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("Status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("Status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("Status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("Status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("Status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("Status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("Status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andCardtypeIsNull() {
            addCriterion("cardtype is null");
            return (Criteria) this;
        }

        public Criteria andCardtypeIsNotNull() {
            addCriterion("cardtype is not null");
            return (Criteria) this;
        }

        public Criteria andCardtypeEqualTo(Integer value) {
            addCriterion("cardtype =", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeNotEqualTo(Integer value) {
            addCriterion("cardtype <>", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeGreaterThan(Integer value) {
            addCriterion("cardtype >", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("cardtype >=", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeLessThan(Integer value) {
            addCriterion("cardtype <", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeLessThanOrEqualTo(Integer value) {
            addCriterion("cardtype <=", value, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeIn(List<Integer> values) {
            addCriterion("cardtype in", values, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeNotIn(List<Integer> values) {
            addCriterion("cardtype not in", values, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeBetween(Integer value1, Integer value2) {
            addCriterion("cardtype between", value1, value2, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardtypeNotBetween(Integer value1, Integer value2) {
            addCriterion("cardtype not between", value1, value2, "cardtype");
            return (Criteria) this;
        }

        public Criteria andCardFirsttimeIsNull() {
            addCriterion("card_firsttime is null");
            return (Criteria) this;
        }

        public Criteria andCardFirsttimeIsNotNull() {
            addCriterion("card_firsttime is not null");
            return (Criteria) this;
        }

        public Criteria andCardFirsttimeEqualTo(Date value) {
            addCriterion("card_firsttime =", value, "cardFirsttime");
            return (Criteria) this;
        }

        public Criteria andCardFirsttimeNotEqualTo(Date value) {
            addCriterion("card_firsttime <>", value, "cardFirsttime");
            return (Criteria) this;
        }

        public Criteria andCardFirsttimeGreaterThan(Date value) {
            addCriterion("card_firsttime >", value, "cardFirsttime");
            return (Criteria) this;
        }

        public Criteria andCardFirsttimeGreaterThanOrEqualTo(Date value) {
            addCriterion("card_firsttime >=", value, "cardFirsttime");
            return (Criteria) this;
        }

        public Criteria andCardFirsttimeLessThan(Date value) {
            addCriterion("card_firsttime <", value, "cardFirsttime");
            return (Criteria) this;
        }

        public Criteria andCardFirsttimeLessThanOrEqualTo(Date value) {
            addCriterion("card_firsttime <=", value, "cardFirsttime");
            return (Criteria) this;
        }

        public Criteria andCardFirsttimeIn(List<Date> values) {
            addCriterion("card_firsttime in", values, "cardFirsttime");
            return (Criteria) this;
        }

        public Criteria andCardFirsttimeNotIn(List<Date> values) {
            addCriterion("card_firsttime not in", values, "cardFirsttime");
            return (Criteria) this;
        }

        public Criteria andCardFirsttimeBetween(Date value1, Date value2) {
            addCriterion("card_firsttime between", value1, value2, "cardFirsttime");
            return (Criteria) this;
        }

        public Criteria andCardFirsttimeNotBetween(Date value1, Date value2) {
            addCriterion("card_firsttime not between", value1, value2, "cardFirsttime");
            return (Criteria) this;
        }

        public Criteria andCardPreEndtimeIsNull() {
            addCriterion("card_pre_endtime is null");
            return (Criteria) this;
        }

        public Criteria andCardPreEndtimeIsNotNull() {
            addCriterion("card_pre_endtime is not null");
            return (Criteria) this;
        }

        public Criteria andCardPreEndtimeEqualTo(Date value) {
            addCriterion("card_pre_endtime =", value, "cardPreEndtime");
            return (Criteria) this;
        }

        public Criteria andCardPreEndtimeNotEqualTo(Date value) {
            addCriterion("card_pre_endtime <>", value, "cardPreEndtime");
            return (Criteria) this;
        }

        public Criteria andCardPreEndtimeGreaterThan(Date value) {
            addCriterion("card_pre_endtime >", value, "cardPreEndtime");
            return (Criteria) this;
        }

        public Criteria andCardPreEndtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("card_pre_endtime >=", value, "cardPreEndtime");
            return (Criteria) this;
        }

        public Criteria andCardPreEndtimeLessThan(Date value) {
            addCriterion("card_pre_endtime <", value, "cardPreEndtime");
            return (Criteria) this;
        }

        public Criteria andCardPreEndtimeLessThanOrEqualTo(Date value) {
            addCriterion("card_pre_endtime <=", value, "cardPreEndtime");
            return (Criteria) this;
        }

        public Criteria andCardPreEndtimeIn(List<Date> values) {
            addCriterion("card_pre_endtime in", values, "cardPreEndtime");
            return (Criteria) this;
        }

        public Criteria andCardPreEndtimeNotIn(List<Date> values) {
            addCriterion("card_pre_endtime not in", values, "cardPreEndtime");
            return (Criteria) this;
        }

        public Criteria andCardPreEndtimeBetween(Date value1, Date value2) {
            addCriterion("card_pre_endtime between", value1, value2, "cardPreEndtime");
            return (Criteria) this;
        }

        public Criteria andCardPreEndtimeNotBetween(Date value1, Date value2) {
            addCriterion("card_pre_endtime not between", value1, value2, "cardPreEndtime");
            return (Criteria) this;
        }

        public Criteria andCardAfterBegintimeIsNull() {
            addCriterion("card_after_begintime is null");
            return (Criteria) this;
        }

        public Criteria andCardAfterBegintimeIsNotNull() {
            addCriterion("card_after_begintime is not null");
            return (Criteria) this;
        }

        public Criteria andCardAfterBegintimeEqualTo(Date value) {
            addCriterion("card_after_begintime =", value, "cardAfterBegintime");
            return (Criteria) this;
        }

        public Criteria andCardAfterBegintimeNotEqualTo(Date value) {
            addCriterion("card_after_begintime <>", value, "cardAfterBegintime");
            return (Criteria) this;
        }

        public Criteria andCardAfterBegintimeGreaterThan(Date value) {
            addCriterion("card_after_begintime >", value, "cardAfterBegintime");
            return (Criteria) this;
        }

        public Criteria andCardAfterBegintimeGreaterThanOrEqualTo(Date value) {
            addCriterion("card_after_begintime >=", value, "cardAfterBegintime");
            return (Criteria) this;
        }

        public Criteria andCardAfterBegintimeLessThan(Date value) {
            addCriterion("card_after_begintime <", value, "cardAfterBegintime");
            return (Criteria) this;
        }

        public Criteria andCardAfterBegintimeLessThanOrEqualTo(Date value) {
            addCriterion("card_after_begintime <=", value, "cardAfterBegintime");
            return (Criteria) this;
        }

        public Criteria andCardAfterBegintimeIn(List<Date> values) {
            addCriterion("card_after_begintime in", values, "cardAfterBegintime");
            return (Criteria) this;
        }

        public Criteria andCardAfterBegintimeNotIn(List<Date> values) {
            addCriterion("card_after_begintime not in", values, "cardAfterBegintime");
            return (Criteria) this;
        }

        public Criteria andCardAfterBegintimeBetween(Date value1, Date value2) {
            addCriterion("card_after_begintime between", value1, value2, "cardAfterBegintime");
            return (Criteria) this;
        }

        public Criteria andCardAfterBegintimeNotBetween(Date value1, Date value2) {
            addCriterion("card_after_begintime not between", value1, value2, "cardAfterBegintime");
            return (Criteria) this;
        }

        public Criteria andCardAfterEndtimeIsNull() {
            addCriterion("card_after_endtime is null");
            return (Criteria) this;
        }

        public Criteria andCardAfterEndtimeIsNotNull() {
            addCriterion("card_after_endtime is not null");
            return (Criteria) this;
        }

        public Criteria andCardAfterEndtimeEqualTo(Date value) {
            addCriterion("card_after_endtime =", value, "cardAfterEndtime");
            return (Criteria) this;
        }

        public Criteria andCardAfterEndtimeNotEqualTo(Date value) {
            addCriterion("card_after_endtime <>", value, "cardAfterEndtime");
            return (Criteria) this;
        }

        public Criteria andCardAfterEndtimeGreaterThan(Date value) {
            addCriterion("card_after_endtime >", value, "cardAfterEndtime");
            return (Criteria) this;
        }

        public Criteria andCardAfterEndtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("card_after_endtime >=", value, "cardAfterEndtime");
            return (Criteria) this;
        }

        public Criteria andCardAfterEndtimeLessThan(Date value) {
            addCriterion("card_after_endtime <", value, "cardAfterEndtime");
            return (Criteria) this;
        }

        public Criteria andCardAfterEndtimeLessThanOrEqualTo(Date value) {
            addCriterion("card_after_endtime <=", value, "cardAfterEndtime");
            return (Criteria) this;
        }

        public Criteria andCardAfterEndtimeIn(List<Date> values) {
            addCriterion("card_after_endtime in", values, "cardAfterEndtime");
            return (Criteria) this;
        }

        public Criteria andCardAfterEndtimeNotIn(List<Date> values) {
            addCriterion("card_after_endtime not in", values, "cardAfterEndtime");
            return (Criteria) this;
        }

        public Criteria andCardAfterEndtimeBetween(Date value1, Date value2) {
            addCriterion("card_after_endtime between", value1, value2, "cardAfterEndtime");
            return (Criteria) this;
        }

        public Criteria andCardAfterEndtimeNotBetween(Date value1, Date value2) {
            addCriterion("card_after_endtime not between", value1, value2, "cardAfterEndtime");
            return (Criteria) this;
        }

        public Criteria andDiscountedamountIsNull() {
            addCriterion("DiscountedAmount is null");
            return (Criteria) this;
        }

        public Criteria andDiscountedamountIsNotNull() {
            addCriterion("DiscountedAmount is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountedamountEqualTo(BigDecimal value) {
            addCriterion("DiscountedAmount =", value, "discountedamount");
            return (Criteria) this;
        }

        public Criteria andDiscountedamountNotEqualTo(BigDecimal value) {
            addCriterion("DiscountedAmount <>", value, "discountedamount");
            return (Criteria) this;
        }

        public Criteria andDiscountedamountGreaterThan(BigDecimal value) {
            addCriterion("DiscountedAmount >", value, "discountedamount");
            return (Criteria) this;
        }

        public Criteria andDiscountedamountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DiscountedAmount >=", value, "discountedamount");
            return (Criteria) this;
        }

        public Criteria andDiscountedamountLessThan(BigDecimal value) {
            addCriterion("DiscountedAmount <", value, "discountedamount");
            return (Criteria) this;
        }

        public Criteria andDiscountedamountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DiscountedAmount <=", value, "discountedamount");
            return (Criteria) this;
        }

        public Criteria andDiscountedamountIn(List<BigDecimal> values) {
            addCriterion("DiscountedAmount in", values, "discountedamount");
            return (Criteria) this;
        }

        public Criteria andDiscountedamountNotIn(List<BigDecimal> values) {
            addCriterion("DiscountedAmount not in", values, "discountedamount");
            return (Criteria) this;
        }

        public Criteria andDiscountedamountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DiscountedAmount between", value1, value2, "discountedamount");
            return (Criteria) this;
        }

        public Criteria andDiscountedamountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DiscountedAmount not between", value1, value2, "discountedamount");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNull() {
            addCriterion("description is null");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNotNull() {
            addCriterion("description is not null");
            return (Criteria) this;
        }

        public Criteria andDescriptionEqualTo(String value) {
            addCriterion("description =", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotEqualTo(String value) {
            addCriterion("description <>", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThan(String value) {
            addCriterion("description >", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("description >=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThan(String value) {
            addCriterion("description <", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThanOrEqualTo(String value) {
            addCriterion("description <=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLike(String value) {
            addCriterion("description like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotLike(String value) {
            addCriterion("description not like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionIn(List<String> values) {
            addCriterion("description in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotIn(List<String> values) {
            addCriterion("description not in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionBetween(String value1, String value2) {
            addCriterion("description between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotBetween(String value1, String value2) {
            addCriterion("description not between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andPrepayidIsNull() {
            addCriterion("prepayid is null");
            return (Criteria) this;
        }

        public Criteria andPrepayidIsNotNull() {
            addCriterion("prepayid is not null");
            return (Criteria) this;
        }

        public Criteria andPrepayidEqualTo(String value) {
            addCriterion("prepayid =", value, "prepayid");
            return (Criteria) this;
        }

        public Criteria andPrepayidNotEqualTo(String value) {
            addCriterion("prepayid <>", value, "prepayid");
            return (Criteria) this;
        }

        public Criteria andPrepayidGreaterThan(String value) {
            addCriterion("prepayid >", value, "prepayid");
            return (Criteria) this;
        }

        public Criteria andPrepayidGreaterThanOrEqualTo(String value) {
            addCriterion("prepayid >=", value, "prepayid");
            return (Criteria) this;
        }

        public Criteria andPrepayidLessThan(String value) {
            addCriterion("prepayid <", value, "prepayid");
            return (Criteria) this;
        }

        public Criteria andPrepayidLessThanOrEqualTo(String value) {
            addCriterion("prepayid <=", value, "prepayid");
            return (Criteria) this;
        }

        public Criteria andPrepayidLike(String value) {
            addCriterion("prepayid like", value, "prepayid");
            return (Criteria) this;
        }

        public Criteria andPrepayidNotLike(String value) {
            addCriterion("prepayid not like", value, "prepayid");
            return (Criteria) this;
        }

        public Criteria andPrepayidIn(List<String> values) {
            addCriterion("prepayid in", values, "prepayid");
            return (Criteria) this;
        }

        public Criteria andPrepayidNotIn(List<String> values) {
            addCriterion("prepayid not in", values, "prepayid");
            return (Criteria) this;
        }

        public Criteria andPrepayidBetween(String value1, String value2) {
            addCriterion("prepayid between", value1, value2, "prepayid");
            return (Criteria) this;
        }

        public Criteria andPrepayidNotBetween(String value1, String value2) {
            addCriterion("prepayid not between", value1, value2, "prepayid");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria implements Serializable {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion implements Serializable {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}